SQL Developer
Kforce Inc
Job Summary
Kforce is seeking a hands-on Senior SQL Developer in Tampa, FL, to reverse engineer and stabilize a legacy MS Access 2003/VBA application. The role involves designing and building modern SQL-centric data flows, implementing integrations with the Infor system, and maintaining on-prem performance and reliability. Key responsibilities include SQL Server schema design, ETL pipeline development, establishing coding standards, and preparing for S4 migration, ensuring secure handling of ERP data.
Must Have
- Deep T-SQL expertise
- Ability to read and write MS Access 2003/VBA code
- Experience with SQL Server schema design
- Proficiency in building ETL/data ingestion pipelines
- Experience integrating with Infor systems
- Knowledge of on-prem performance tuning (indexing, query tuning)
- Familiarity with coding standards, version control, and technical documentation
- Ability to implement unit/integration test harnesses
- Experience mapping legacy rules to modern data structures
- Skills in preparing for S4 migration
- Understanding of secure ERP data handling
Perks & Benefits
- Medical/dental/vision insurance
- HSA
- FSA
- 401(k)
- Life, disability & ADD insurance
- Paid time off (for salaried personnel)
- Paid sick leave (for hourly employees on a Service Contract Act project)
Job Description
Kforce has a client that is seeking an SQL Developer in Tampa, FL. Summary: We're seeking a hands-on Senior SQL Developer with deep T SQL expertise and the ability to read and write MS Access 2003/VBA. You'll reverse engineer and stabilize the legacy application, design and build modern SQL centric data flows, and implement integrations that connect the current Access front end (on prem) + SQL Server back-end ERP with the modern Infor system. The near-term focus is delivering the first integration, followed by a broader modernization program. Duties:
- Reverse engineer, read, and author MS Access 2003/VBA code; Untangle ~100k lines of legacy logic to document workflows and stabilize critical functions
- Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into system) to support modernized processing
- Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); Automate validation and reconciliation
- Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem
- Maintain on prem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity
- Establish coding standards, version control, and technical documentation for legacy and modern components; Implement unit/integration test harnesses
- Partner with business (estimators, dealers) to map legacy rules to modern data structures; Convert tribal knowledge into testable specifications
- Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets
- Drive secure handling of ERP data (authentication, role-based access, auditing), and plan for multi-year on prem operation before any cloud move
Requirements
------------
- To be considered for this position, candidates must have experience in a similar role, or they must possess significant knowledge, experience, and abilities to successfully perform the responsibilities listed
- Relevant education and/or training will be considered a plus
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.